시퀀스 추가

가짜 pseudo 필드 nextval을 이용

create sequence sequence_lession
START WITH 1
INCREMENT BY 1
nocache;


insert into lession(courseid)
values(sequence_lession.nextval);

CREATE TABLE student(
	std_seq NUMBER(5),
	std_no VARCHAR2(10),
	std_name VARCHAR2(10),
	std_addr VARCHAR2(100),
	std_age VARCHAR2(3),
	std_birth DATE,
	crs_no number(5),
	prf_no NUMBER(5),
	cs_time VARCHAR2(20)

);


INSERT into student(std_seq)
values (sequence_lession.nextval);